package DBLayer;

import java.util.ArrayList;

import ModelLayer.SalesOrder;

public interface IFDBSalesOrder {
	public int getNextSalesOrderId();
	//get all SalesOrders
    public ArrayList<SalesOrder> getAllSalesOrder();
    //find a SalesOrder using the id.
    public SalesOrder getSalesOrderById(int salesOrderId);
    //find SalesOrders by Customer id
    public ArrayList<SalesOrder> getSalesOrderByCustomerId(int customerId);
    //find SalesOrder by Employee id
    public ArrayList<SalesOrder> getSalesOrderByEmployeeId(int employeeId);
    //find SalesOrders by status
    public ArrayList<SalesOrder> getSalesOrdersByStatus(String status);
    //find SalesOrders by deliveryId
    public ArrayList<SalesOrder> getSalesOrdersByDeliveryId(int deliveryId);
    //insert new SalesOrder
    public int insertSalesOrder(SalesOrder salesOrder) throws Exception;
    //update SalesOrder
    public int updateSalesOrder(SalesOrder salesOrder);
    //delete SalesOrder
    public int deleteSalesOrder(SalesOrder salesOrder);
}
